﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ayrintiverecek.aspx.cs" Inherits="OnlineDovizOtomasyonu.ayrintiverecek" %>

<%@ Register Assembly="DevExpress.Web.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxRoundPanel" TagPrefix="dx" %>

<%@ Register assembly="DevExpress.Web.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPanel" tagprefix="dx" %>

<%@ Register assembly="DevExpress.Web.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxSplitter" tagprefix="dx" %>

<%@ Register assembly="DevExpress.Web.ASPxGridView.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>

<%@ Register assembly="DevExpress.Web.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxMenu" tagprefix="dx" %>

<%@ Register assembly="DevExpress.Web.ASPxGridView.v12.1.Export, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView.Export" tagprefix="dx" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>Webing Online Döviz Hesap Otomasyonu | Verecek Ayrıntısı</title>
    <link href="css/stil.css" rel="stylesheet" type="text/css" />
    
</head>
<body>
    <form id="form1" runat="server">
    <div class="AlacakAyrintiGenelDiv">
        <dx:ASPxRoundPanel ID="PanelUst" runat="server" Width="100%" 
            HeaderText="Verecek Ayrıntı Sayfası" Height="100%" Theme="Aqua">
            <PanelCollection>
<dx:PanelContent ID="PanelContent1" runat="server" SupportsDisabledAttribute="True">
    <table cellpadding="0" cellspacing="0" width="100%">
    <tr>
    <td width="150">
    
        <dx:ASPxMenu ID="AyrintiMenu" runat="server" EnableTheming="True" 
            OnItemClick="AyrintiMenu_ItemClick" Theme="Aqua">
            <Items>
                <dx:MenuItem Name="M1" NavigateUrl="~/hesapdefteri.aspx" 
                    Text="Hesap Defterine Dön">
                    <Image Url="~/images/icon/geri.png">
                    </Image>
                </dx:MenuItem>
                <dx:MenuItem Name="M2" Text="Excel Aktar">
                    <Image Url="~/images/icon/excel1.png">
                    </Image>
                </dx:MenuItem>
                <dx:MenuItem Name="M3" Text="Pdf Aktar">
                    <Image Url="~/images/icon/pdf.png">
                    </Image>
                </dx:MenuItem>
                <dx:MenuItem Name="M4" Text="Mail Gönder">
                    <Image Url="~/images/icon/mail1.png">
                    </Image>
                </dx:MenuItem>
                <dx:MenuItem Name="M5" Text="Çıkış Yap">
                    <Image Url="~/images/icon/kapat.png">
                    </Image>
                </dx:MenuItem>
            </Items>
        </dx:ASPxMenu>
        </td>
    
    </tr>
        <tr>
            <td width="100%" height="100%">
                <dx:ASPxGridView ID="listeVerecekAyrinti" runat="server" AutoGenerateColumns="False" 
                    DataSourceID="sdAyrintiVerecek" EnableTheming="True" KeyFieldName="ID" 
                    Theme="Aqua" Width="100%">
                    
                    <TotalSummary>
                        <dx:ASPxSummaryItem DisplayFormat="{0}" FieldName="TL" SummaryType="Sum" />
                        <dx:ASPxSummaryItem DisplayFormat="{0}" FieldName="USD" SummaryType="Sum" />
                        <dx:ASPxSummaryItem DisplayFormat="{0}" FieldName="EURO" SummaryType="Sum" />
                        <dx:ASPxSummaryItem DisplayFormat="{0}" FieldName="SAR" SummaryType="Sum" />
                        <dx:ASPxSummaryItem DisplayFormat="{0}" FieldName="SRY" SummaryType="Sum" />
                    </TotalSummary>
                    <Columns>
                        <dx:GridViewCommandColumn ButtonType="Image" Caption="İşlemler" 
                            ShowInCustomizationForm="True" VisibleIndex="10" Width="50px">
                            <EditButton Visible="True">
                                <Image ToolTip="Düzenle" Url="~/images/icon/duzenle.png">
                                </Image>
                            </EditButton>
                            <DeleteButton Visible="True">
                                <Image ToolTip="Sil" Url="~/images/icon/sil.png">
                                </Image>
                            </DeleteButton>
                            <CancelButton>
                                <Image ToolTip="Vazgeç" Url="~/images/icon/vazgec.png">
                                </Image>
                            </CancelButton>
                            <UpdateButton>
                                <Image ToolTip="Kaydet" Url="~/images/icon/kaydet.png">
                                </Image>
                            </UpdateButton>
                        </dx:GridViewCommandColumn>
                        <dx:GridViewDataTextColumn FieldName="ID" ReadOnly="True" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="0">
                            <EditFormSettings Visible="False" />
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="MUSTERIKODU" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="1">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataDateColumn Caption="İşlem Tarihi" FieldName="TARIH" 
                            ShowInCustomizationForm="True" VisibleIndex="2" Width="10%">
                        </dx:GridViewDataDateColumn>
                        <dx:GridViewDataTextColumn FieldName="TIPI" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="3">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Tl" FieldName="TL" 
                            ShowInCustomizationForm="True" VisibleIndex="4" Width="10%">
                            <HeaderStyle>
                            <BackgroundImage HorizontalPosition="right" 
                                ImageUrl="~/images/icon/parabirim/tl.png" Repeat="NoRepeat" />
                            </HeaderStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Usd" FieldName="USD" 
                            ShowInCustomizationForm="True" VisibleIndex="5" Width="10%">
                            <HeaderStyle>
                            <BackgroundImage HorizontalPosition="right" 
                                ImageUrl="~/images/icon/parabirim/dolar.png" Repeat="NoRepeat" />
                            </HeaderStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Euro" FieldName="EURO" 
                            ShowInCustomizationForm="True" VisibleIndex="6" Width="10%">
                            <HeaderStyle>
                            <BackgroundImage HorizontalPosition="right" 
                                ImageUrl="~/images/icon/parabirim/euro.png" Repeat="NoRepeat" />
                            </HeaderStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Sar" FieldName="SAR" 
                            ShowInCustomizationForm="True" VisibleIndex="7" Width="10%">
                            <HeaderStyle>
                            <BackgroundImage HorizontalPosition="right" 
                                ImageUrl="~/images/icon/parabirim/iranian-rial.png" Repeat="NoRepeat" />
                            </HeaderStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Sry" FieldName="SRY" 
                            ShowInCustomizationForm="True" VisibleIndex="8" Width="10%">
                            <HeaderStyle>
                            <BackgroundImage HorizontalPosition="right" 
                                ImageUrl="~/images/icon/parabirim/sry.png" Repeat="NoRepeat" />
                            </HeaderStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataMemoColumn Caption="Açıklama" FieldName="ACIKLAMA" 
                            ShowInCustomizationForm="True" VisibleIndex="9" Width="40%">
                        </dx:GridViewDataMemoColumn>
                        <dx:GridViewDataTextColumn FieldName="KESIM" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="11">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <SettingsBehavior AllowFocusedRow="True" ConfirmDelete="True" />
                    <SettingsPager NumericButtonCount="20" PageSize="20">
                        <Summary AllPagesText="Sayfalar: {0} - {1} ({2} Kayıtlar)" 
                            Text="Sayfa {0} İle {1} ({2} kayıt)" />
                    </SettingsPager>
                    <SettingsEditing EditFormColumnCount="1" Mode="PopupEditForm" />
                    <Settings ShowFilterRow="True" ShowFilterRowMenu="False" ShowFooter="True" 
                        ShowGroupPanel="True" />
                    <SettingsText EmptyDataRow="Herhangi Bir Veri Bulunamadı!" 
                        GroupPanel="Sütuna Göre Gruplama Yapmak İçin Kolon Sürükleyin." 
                        PopupEditFormCaption="Veri Düzenleme" 
                        ConfirmDelete="Kaydı Silmek İstediğinize Eminmisiniz?" />
                    <SettingsLoadingPanel Text="Lütfen Bekleyin..." />
                    <SettingsPopup>
                        <EditForm Height="300px" HorizontalAlign="WindowCenter" Modal="True" 
                            VerticalAlign="WindowCenter" Width="300px" />
                        <CustomizationWindow Height="500px" Width="500px" />
                    </SettingsPopup>
                    <Styles>
                        <Footer Font-Bold="True">
                        </Footer>
                    </Styles>
                    <StylesPopup>
                        <Common>
                            <ModalBackground>
                                <BackgroundImage HorizontalPosition="left" 
                                    ImageUrl="~/images/zeminler/siyahcizgili.JPG" VerticalPosition="top" />
                            </ModalBackground>
                        </Common>
                        <EditForm>
                            <Header>
                                <BackgroundImage HorizontalPosition="left" ImageUrl="~/images/icon/duzenle.png" 
                                    Repeat="NoRepeat" VerticalPosition="center" />
                            </Header>
                            <ModalBackground>
                                <BackgroundImage HorizontalPosition="left" 
                                    ImageUrl="~/images/zeminler/beyazcizgili.JPG" VerticalPosition="top" />
                            </ModalBackground>
                        </EditForm>
                    </StylesPopup>
                </dx:ASPxGridView>
                
                <dx:ASPxGridViewExporter ID="listeexport" runat="server" 
                    GridViewID="listeVerecekAyrinti" PaperKind="A4" ReportFooter="{\rtf1\ansi\ansicpg1254\deff0\deflang1055{\fonttbl{\f0\fnil\fcharset162{\*\fname Times New Roman;}Times New Roman TUR;}}
\viewkind4\uc1\pard\qc\f0\fs20 Bu Rapor Bilgilendirme Ama\'e7l\'fdd\'fdr. Hi\'e7 Bir Surette Mali De\'f0eri Yoktur.\par
}
" ReportHeader="{\rtf1\ansi\ansicpg1254\deff0\deflang1055{\fonttbl{\f0\fnil\fcharset162{\*\fname Times New Roman;}Times New Roman TUR;}}
{\colortbl ;\red64\green64\blue64;}
\viewkind4\uc1\pard\cf1\b\f0\fs28 VERECEK AYRINTI RAPORU\cf0\b0\fs20\par
}
">
                </dx:ASPxGridViewExporter>
                
                <asp:SqlDataSource ID="sdAyrintiVerecek" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" 
                    
                    SelectCommand="SELECT * FROM [TBLDEFTER] WHERE (([MUSTERIKODU] = @MUSTERIKODU) AND ([TIPI] = @TIPI) AND ([KESIM] = @KESIM)) ORDER BY [TARIH]" 
                    ConflictDetection="CompareAllValues" 
                    DeleteCommand="DELETE FROM [TBLDEFTER] WHERE [ID] = @original_ID AND (([MUSTERIKODU] = @original_MUSTERIKODU) OR ([MUSTERIKODU] IS NULL AND @original_MUSTERIKODU IS NULL)) AND (([TARIH] = @original_TARIH) OR ([TARIH] IS NULL AND @original_TARIH IS NULL)) AND (([TIPI] = @original_TIPI) OR ([TIPI] IS NULL AND @original_TIPI IS NULL)) AND (([TL] = @original_TL) OR ([TL] IS NULL AND @original_TL IS NULL)) AND (([USD] = @original_USD) OR ([USD] IS NULL AND @original_USD IS NULL)) AND (([EURO] = @original_EURO) OR ([EURO] IS NULL AND @original_EURO IS NULL)) AND (([SAR] = @original_SAR) OR ([SAR] IS NULL AND @original_SAR IS NULL)) AND (([SRY] = @original_SRY) OR ([SRY] IS NULL AND @original_SRY IS NULL)) AND (([ACIKLAMA] = @original_ACIKLAMA) OR ([ACIKLAMA] IS NULL AND @original_ACIKLAMA IS NULL)) AND (([KESIM] = @original_KESIM) OR ([KESIM] IS NULL AND @original_KESIM IS NULL))" 
                    InsertCommand="INSERT INTO [TBLDEFTER] ([MUSTERIKODU], [TARIH], [TIPI], [TL], [USD], [EURO], [SAR], [SRY], [ACIKLAMA], [KESIM]) VALUES (@MUSTERIKODU, @TARIH, @TIPI, @TL, @USD, @EURO, @SAR, @SRY, @ACIKLAMA, @KESIM)" 
                    OldValuesParameterFormatString="original_{0}" 
                    UpdateCommand="UPDATE [TBLDEFTER] SET [MUSTERIKODU] = @MUSTERIKODU, [TARIH] = @TARIH, [TIPI] = @TIPI, [TL] = @TL, [USD] = @USD, [EURO] = @EURO, [SAR] = @SAR, [SRY] = @SRY, [ACIKLAMA] = @ACIKLAMA, [KESIM] = @KESIM WHERE [ID] = @original_ID AND (([MUSTERIKODU] = @original_MUSTERIKODU) OR ([MUSTERIKODU] IS NULL AND @original_MUSTERIKODU IS NULL)) AND (([TARIH] = @original_TARIH) OR ([TARIH] IS NULL AND @original_TARIH IS NULL)) AND (([TIPI] = @original_TIPI) OR ([TIPI] IS NULL AND @original_TIPI IS NULL)) AND (([TL] = @original_TL) OR ([TL] IS NULL AND @original_TL IS NULL)) AND (([USD] = @original_USD) OR ([USD] IS NULL AND @original_USD IS NULL)) AND (([EURO] = @original_EURO) OR ([EURO] IS NULL AND @original_EURO IS NULL)) AND (([SAR] = @original_SAR) OR ([SAR] IS NULL AND @original_SAR IS NULL)) AND (([SRY] = @original_SRY) OR ([SRY] IS NULL AND @original_SRY IS NULL)) AND (([ACIKLAMA] = @original_ACIKLAMA) OR ([ACIKLAMA] IS NULL AND @original_ACIKLAMA IS NULL)) AND (([KESIM] = @original_KESIM) OR ([KESIM] IS NULL AND @original_KESIM IS NULL))">
                    <DeleteParameters>
                        <asp:Parameter Name="original_ID" Type="Int32" />
                        <asp:Parameter Name="original_MUSTERIKODU" Type="Int32" />
                        <asp:Parameter DbType="Date" Name="original_TARIH" />
                        <asp:Parameter Name="original_TIPI" Type="String" />
                        <asp:Parameter Name="original_TL" Type="Decimal" />
                        <asp:Parameter Name="original_USD" Type="Decimal" />
                        <asp:Parameter Name="original_EURO" Type="Decimal" />
                        <asp:Parameter Name="original_SAR" Type="Decimal" />
                        <asp:Parameter Name="original_SRY" Type="Decimal" />
                        <asp:Parameter Name="original_ACIKLAMA" Type="String" />
                        <asp:Parameter Name="original_KESIM" Type="Int32" />
                    </DeleteParameters>
                    <InsertParameters>
                        <asp:Parameter Name="MUSTERIKODU" Type="Int32" />
                        <asp:Parameter DbType="Date" Name="TARIH" />
                        <asp:Parameter Name="TIPI" Type="String" />
                        <asp:Parameter Name="TL" Type="Decimal" />
                        <asp:Parameter Name="USD" Type="Decimal" />
                        <asp:Parameter Name="EURO" Type="Decimal" />
                        <asp:Parameter Name="SAR" Type="Decimal" />
                        <asp:Parameter Name="SRY" Type="Decimal" />
                        <asp:Parameter Name="ACIKLAMA" Type="String" />
                        <asp:Parameter Name="KESIM" Type="Int32" />
                    </InsertParameters>
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="-1" Name="MUSTERIKODU" 
                            SessionField="webingMK" Type="Int32" />
                        <asp:Parameter DefaultValue="V" Name="TIPI" Type="String" />
                        <asp:Parameter DefaultValue="0" Name="KESIM" Type="Int32" />
                    </SelectParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="MUSTERIKODU" Type="Int32" />
                        <asp:Parameter DbType="Date" Name="TARIH" />
                        <asp:Parameter Name="TIPI" Type="String" />
                        <asp:Parameter Name="TL" Type="Decimal" />
                        <asp:Parameter Name="USD" Type="Decimal" />
                        <asp:Parameter Name="EURO" Type="Decimal" />
                        <asp:Parameter Name="SAR" Type="Decimal" />
                        <asp:Parameter Name="SRY" Type="Decimal" />
                        <asp:Parameter Name="ACIKLAMA" Type="String" />
                        <asp:Parameter Name="KESIM" Type="Int32" />
                        <asp:Parameter Name="original_ID" Type="Int32" />
                        <asp:Parameter Name="original_MUSTERIKODU" Type="Int32" />
                        <asp:Parameter DbType="Date" Name="original_TARIH" />
                        <asp:Parameter Name="original_TIPI" Type="String" />
                        <asp:Parameter Name="original_TL" Type="Decimal" />
                        <asp:Parameter Name="original_USD" Type="Decimal" />
                        <asp:Parameter Name="original_EURO" Type="Decimal" />
                        <asp:Parameter Name="original_SAR" Type="Decimal" />
                        <asp:Parameter Name="original_SRY" Type="Decimal" />
                        <asp:Parameter Name="original_ACIKLAMA" Type="String" />
                        <asp:Parameter Name="original_KESIM" Type="Int32" />
                    </UpdateParameters>
                </asp:SqlDataSource>
                <%--<dx:ASPxPopupMenu ID="ASPxPopupMenu1" runat="server">
                    <Items>
                        <dx:MenuItem Text="Hesap Defterine Dön">
                        </dx:MenuItem>
                        <dx:MenuItem BeginGroup="True" Text="Excel Aktar">
                        </dx:MenuItem>
                        <dx:MenuItem BeginGroup="True" Text="Pdf Aktar">
                        </dx:MenuItem>
                        <dx:MenuItem BeginGroup="True" Text="Çıkış Yap">
                        </dx:MenuItem>
                    </Items>
                </dx:ASPxPopupMenu>--%>
            </td>
        </tr>
    </table>
                </dx:PanelContent>
</PanelCollection>
        </dx:ASPxRoundPanel>
    </div>
    <%--<dx:ASPxPopupMenu ID="ASPxPopupMenu1" runat="server">
                    <Items>
                        <dx:MenuItem Text="Hesap Defterine Dön">
                        </dx:MenuItem>
                        <dx:MenuItem BeginGroup="True" Text="Excel Aktar">
                        </dx:MenuItem>
                        <dx:MenuItem BeginGroup="True" Text="Pdf Aktar">
                        </dx:MenuItem>
                        <dx:MenuItem BeginGroup="True" Text="Çıkış Yap">
                        </dx:MenuItem>
                    </Items>
                </dx:ASPxPopupMenu>--%>
    </form>
</body>
</html>